Data READs with Parameters
In this post, We’ll focus on how to read a OData service with a parameter.
Service method with a parameter

Now, we’ll see how to retrieve data with a parameter,
Url in the browser

In browser, we can see only filtered students. in url, append the parameter with values.
Power Query Window

From the Power Query window, we can see dataset like this.
I could create a github repo for this code sample, Please feel free to check it, https://github.com/hansamaligamage/ODATAExample